Hệ thống quản lý trường đại học bằng PHP
1 <?php
2 require_once('../includes/config.php');
3 if(!$user->is_logged_in()){
4 header('Location: ../login.php');
5 }
6 ?>
7 <!DOCTYPE html>
8 <html>
9 <head>
10 <meta charset="utf-8">
11 <meta name="viewport" content="width=device-width, initial-scale=1">
12 <title>Students Edit</title>
13
14 <link href="css/bootstrap.min.css" rel="stylesheet">
15 <link href="css/datepicker3.css" rel="stylesheet">
16 <link href="css/bootstrap-table.css" rel="stylesheet">
17 <link href="css/styles.css" rel="stylesheet">
18
19 <!--Icons-->
20 <script src="js/lumino.glyphs.js"></script>
21
22 <!--[if lt IE 9]>
23 <script src="js/html5shiv.js"></script>
24 <script src="js/respond.min.js"></script>
25 <![endif]-->
26
27 </head>
28
29 <body>
30 <?php
31 require_once('includes/common.php');
32 ?>
33
34 <div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">
35 <div class="row">
36 <ol class="breadcrumb">
37 </ol>
38 </div><!--/.row-->
39 <div class="row">
40 <div class="col-lg-12">
41 <div class="panel panel-default">
42 <div class="panel-heading">Students List</div>
43 <div class="panel-body">
44 <table data-toggle="table" data-show-refresh="true" data-show-toggle="true" data-show-columns="true" data-search="true" data-select-item-name="toolbar1" data-pagination="true" data-sort-name="name" data-sort-order="desc">
45 <thead>
46 <tr>
47 <th data-sortable="true">CIN</th>
48 <th ddata-sortable="true">Carte Etudiant</th>
49 <th data-sortable="true">Prenom</th>
50 <th data-sortable="true">Nom</th>
51 <th data-sortable="true">Fillière</th>
52 </tr>
53 </thead>
54 <tbody>
55 <?php
56 try {
57 $stmt = $db->query('SELECT * FROM etudiant INNER JOIN filierefullinfo ON etudiant.filiereID = filierefullinfo.filiereID;');
58 while($row = $stmt->fetch()){
59 echo "<tr><td>".$row['cin']."</td><td>".$row['carteEtudiant']."</td><td>".$row['prenom']."</td><td>".$row['nom']."</td><td>".$row['full_name']."</td></tr>";
60 }
61 }catch(PDOException $e) {
62 echo $e->getMessage();
63 }
64 ?>
65
66 </tbody>
67 </table>
68 </div>
69 </div>
70
71
72 <div class="panel panel-default">
73 <div class="panel-heading">Add Student</div>
74 <div class="panel-body">
75 <div class="col-md-6">
76 <form role="form" action="useradd.php" method="POST">
77
78 <div class="form-group">
79 <label>Prenom</label>
80 <input class="form-control" name="prenom">
81 </div>
82 <div class="form-group">
83 <label>Nom</label>
84 <input class="form-control" name="nom">
85 </div>
86
87 <div class="form-group">
88 <label>Fillière</label>
89 <select class="form-control" name="filliere">
90 <option value="1">Génie Logiciel</option>
91 <option value="2">Informatique Industrielle et Automatique</option>
92 <option value="3">Réseaux Informatiques et Télécommunications</option>
93 <option value="4">Instrumentation et Maintenance Industrielle</option>
94 <option value="5">Chimie Industrielle</option>
95 <option value="6">Biologie industrielle</option>
96 <option value="7">Tronc Commun MPI</option>
97 <option value="8">Tronc Commun CBA</option>
98
99 </select>
100 </div>
101
102 </div>
103 <div class="col-md-6">
104 <div class="form-group">
105 <div class="form-group">
106 <label>Cin</label>
107 <input class="form-control" name="cin" type="number">
108 </div>
109 <div class="form-group">
110 <label>Numero carte etudiant</label>
111 <input class="form-control" name="carteEtudiant" type="number">
112 </div>
113 </div>
114
115 <button type="submit" name="submit" class="btn btn-primary">Submit Button</button>
116 <button type="reset" class="btn btn-default">Reset Button</button>
117 </div>
118 </form>
119 </div>
120 </div>
121 </div>
122 </div><!--/.row-->
123 </div><!--/.main-->
124
125 <script src="js/jquery-1.11.1.min.js"></script>
126 <script src="js/bootstrap.min.js"></script>
127 <script src="js/chart.min.js"></script>
128 <script src="js/chart-data.js"></script>
129 <script src="js/easypiechart.js"></script>
130 <script src="js/easypiechart-data.js"></script>
131 <script src="js/bootstrap-datepicker.js"></script>
132 <script src="js/bootstrap-table.js"></script>
133 <script>
134 !function ($) {
135 $(document).on("click","ul.nav li.parent > a > span.icon", function(){
136 $(this).find('em:first').toggleClass("glyphicon-minus");
137 });
138 $(".sidebar span.icon").find('em:first').addClass("glyphicon-plus");
139 }(window.jQuery);
140
141 $(window).on('resize', function () {
142 if ($(window).width() > 768) $('#sidebar-collapse').collapse('show')
143 })
144 $(window).on('resize', function () {
145 if ($(window).width() <= 767) $('#sidebar-collapse').collapse('hide')
146 })
147 </script>
148 </body>
149
150 </html>